womenadverseeventcomplains
Table: womenadverseeventcomplains
The womenadverseeventcomplains table stores individual complaints associated with a women’s adverse event.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| womenAdverseEventComplainId | int(11) | NO | Primary key for each complaint |
| createdDate | datetime | YES | Timestamp when complaint was created |
| lastEditedDate | datetime | YES | Timestamp when complaint was last edited |
| complain | varchar(255) | YES | Complaint description |
| other | varchar(255) | YES | Additional details if any |
| womenAdverseEventId | int(11) | YES | Reference to the related adverse event |
| createdByUserId | int(11) | YES | User who created the record |
| lastEditedByUserId | int(11) | YES | User who last edited the record |
Indexes
- No specific indexes besides primary key
Foreign Key Relations
womenAdverseEventId → womenadverseevent.womenAdverseEventId
Usage Notes
- Allows multiple complaints per adverse event.
- Helps in detailed tracking of reported issues and user follow-up.